﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.Text;
using System.Data;
using OF.Lib.Utility;

namespace UnitTestProj
{
    public class Customer
    {
        public Customer()
        {
            RefReviews = new List<Review>();
            RefBooks = new List<Book>();
        }

        public int SysNo { get; set; }
        public string LoginId { get; set; }

        public string Name { get; set; }
        public string Phone { get; set; }
        public DateTime? InDate { get; set; }
        public CommonStatus? CommonStatus { get; set; }
        public string Memo { get; set; }
        public virtual List<Review> RefReviews { get; set; }
        public virtual List<Book> RefBooks { get; set; }
    }

    public class Book
    {
        public Book()
        {
            RefReviews = new List<Review>();
        }
        public int SysNo { get; set; }
        public string Title { get; set; }
        public string Author { get; set; }
        public decimal Price { get; set; }
        public DateTime? InDate { get; set; }
        public string Memo { get; set; }
        public virtual List<Review> RefReviews { get; set; }
    }

    public class Review
    {
        public int SysNo { get; set; }
        public int CustomerSysNo { get; set; }
        public int BookSysNo { get; set; }
        public string Title { get; set; }
        public string ReviewDesc { get; set; }
        public DateTime? InDate { get; set; }

        public virtual Book RefBook { get; set; }
    }


    public class QF_Review : QueryFilter
    {
        public List<int> SysNoList { get; set; }
        public string LoginId { get; set; }
        public DateTime? start { get; set; }
        public DateTime? end { get; set; }
    }


    public class QR_Review
    {
        public int SysNo { get; set; }
        public int CustomerSysNo { get; set; }
        public int BookSysNo { get; set; }
        public string Title { get; set; }
        public DateTime? InDate { get; set; }
        public string Name { get; set; }
        public string BookTitle { get; set; }
        public float Price { get; set; }

    }
}
